use master;
GO;
Create Database Test;
GO;
Use Test;
Create Table BlobTest
(
Id int identity(1,1),
BlobName nvarchar(128),
BlobTag nvarchar(512),
BlobData varbinary(MAX)
);

INSERT INTO BlobTest(BlobName, BlobData)
SELECT  'First test file',BulkColumn
FROM OPENROWSET(BULK N'C:\workspace\awork\pic\2011-1-5\mock-up-site.png', SINGLE_BLOB) AS Document;

--OPENROWSET BULK
--    CREATE TABLE Employees   
--    (   
--        Id int,   
--        Name varchar(50) ,   
--        Photo varbinary(max)    
--    )   
--    INSERT INTO Employees(id,name,photo) SELECT BulkColumn from Openrowset( Bulk 'd:/test/0.jpg', Single_Blob) as EmployeePicture   
--    update Employees set photo=(SELECT * from Openrowset( Bulk 'd:/test/0.jpg', Single_Blob)as alias)   